SQLite

SQLite class provides mechanisms to interact with a SQLite database on the Android platform. It implements Driver, Driver.Pool, and Driver.Transactional interfaces, offering functionalities such as connection pooling, executing queries, fetching data, and handling transactions.

The URL uses the same sqlx-style format as the other targets:

• sqlite::memory: - Creates an in-memory database

• sqlite:database.db / sqlite://database.db - Creates/opens a database file in the app's databases directory (see Context.getDatabasePath)

• sqlite:///path/to/database.db - Uses an absolute path

• sqlite:///path/to/database.db?mode=ro - Opens read-only. mode may be ro, rw (never creates), rwc or memory; without it the file is created when missing. cache is accepted but ignored: Android manages its own cache, and in-memory pools are limited to one connection anyway. Any other parameter (immutable, vfs, ...) cannot be honoured on Android and is rejected.

If the URL does not start with "sqlite:", it will be automatically prefixed.

Parameters